USE ChinaDW;
GO
DROP TABLE IF EXISTS DW.DIM_DLAUNCH_USER_INFO;
GO
DROP TABLE IF EXISTS DW.FACT_DLAUNCH_VISIT_RECORD;
GO
DROP TABLE IF EXISTS DW.FACT_DLAUNCH_VISIT_SUMMARY;
GO
DROP TABLE IF EXISTS DW.DIM_DLAUNCH_LIST;
GO
DROP VIEW IF EXISTS DW.VW_T_DIM_DLAUNCH_USER_INFO;
GO
DROP VIEW IF EXISTS DW.VW_T_FACT_DBM_DLAUNCH_VISIT_SUMMARY;
GO
DROP PROCEDURE IF EXISTS DW.SP_DIM_DLAUNCH_LIST;
GO
DROP PROCEDURE IF EXISTS DW.SP_DIM_DLAUNCH_USER_INFO;
GO
DROP PROCEDURE IF EXISTS DW.SP_FACT_DLAUNCH_VISIT_RECORD;
GO
DROP PROCEDURE IF EXISTS DW.SP_FACT_DLAUNCH_VISIT_SUMMARY;
GO
DROP TABLE IF EXISTS ODS.DBM_ACT_DLAUNCH_ACCESS_RECORD;
GO
DROP TABLE IF EXISTS ODS.DBM_ACT_DLAUNCH_ANSWER_RECORD;
GO
DROP TABLE IF EXISTS ODS.DBM_ACT_DLAUNCH_PAGE_RECORD;
GO
DROP TABLE IF EXISTS ODS.DBM_ACT_DLAUNCH_VIDEO_RECORD;
GO
DROP TABLE IF EXISTS ODS.EXCEL_DLAUNCH_RPM_MANUAL_INPUT;
GO
DROP TABLE IF EXISTS ODS.EXCEL_DLAUNCH_LIST;
GO
DROP TABLE IF EXISTS ODS.EXCEL_DLAUNCH_PAGE_CODE_FILTER;
GO
DROP PROCEDURE IF EXISTS ODS.SP_DBM_ACT_DLAUNCH_ANSWER_RECORD_INITIALIZE;
GO
DROP PROCEDURE IF EXISTS ODS.SP_DBM_ACT_DLAUNCH_ACCESS_RECORD_INITIALIZE;
GO
DROP PROCEDURE IF EXISTS ODS.SP_DBM_ACT_DLAUNCH_VIDEO_RECORD_INITIALIZE;
GO
DROP PROCEDURE IF EXISTS ODS.SP_DBM_ACT_DLAUNCH_PAGE_RECORD_INITIALIZE;
GO
DROP PROCEDURE IF EXISTS ODS.SP_DBM_ACT_DLAUNCH_ACCESS_RECORD;
GO
DROP PROCEDURE IF EXISTS ODS.SP_DBM_ACT_DLAUNCH_ANSWER_RECORD;
GO
DROP PROCEDURE IF EXISTS ODS.SP_DBM_ACT_DLAUNCH_PAGE_RECORD;
GO
DROP PROCEDURE IF EXISTS ODS.SP_DBM_ACT_DLAUNCH_VIDEO_RECORD;
GO
DROP TABLE IF EXISTS STG.DBM_DLAUNCH_VISIT_RECORD;
GO
DROP VIEW IF EXISTS STG.VW_T_DBM_DLAUNCH_RECORD;
GO
DROP PROCEDURE IF EXISTS STG.SP_DBM_DLAUNCH_VISIT_RECORD;
GO
UPDATE ODS.DW_SP_INFO SET IsDeleted =1 WHERE Project = 'Dlaunch';